--------------------------------------------------------
--  DDL for Table SYS_GROUP_RULE
--------------------------------------------------------
  CREATE TABLE "APPLICATION_GROUP_RULE" 
   (
  "APPLICATION_KEY" VARCHAR2(36 BYTE),
  "GROUP_ID" VARCHAR2(50 BYTE), 
	"OBJECT_ID" VARCHAR2(50 BYTE), 
	"RULE_ID"  NUMBER(8), 
	"ACTIVE" CHAR(1 BYTE)
   );
   
--------------------------------------------------------
--  DDL for Index APPLICATION_GROUP_RULE_PK
--------------------------------------------------------
  CREATE UNIQUE INDEX "APPLICATION_GROUP_RULE_PK" ON "APPLICATION_GROUP_RULE" ("APPLICATION_KEY", "GROUP_ID", "OBJECT_ID", "RULE_ID")   ;
  
--------------------------------------------------------
--  Constraints for Table SYS_GROUP_RULE
--------------------------------------------------------
  ALTER TABLE "APPLICATION_GROUP_RULE" MODIFY ("APPLICATION_KEY" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_GROUP_RULE" MODIFY ("RULE_ID" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_GROUP_RULE" MODIFY ("GROUP_ID" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_GROUP_RULE" MODIFY ("OBJECT_ID" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_GROUP_RULE" ADD CONSTRAINT "APPLICATION_GROUP_RULE_PK" PRIMARY KEY ("APPLICATION_KEY", "GROUP_ID", "OBJECT_ID", "RULE_ID");
